Determining Service Pack levels

Problem

You cannot determine the current Service Pack of your SQL Server environment, which might be needed for verifying system requirements or working with ASI Technical Support to troubleshoot a problem.

Solution

To determine the current Service Pack level of your Windows operating system, you can use your SQL Server management environment to run the following SQL Query:

SELECT @@ version

To determine the current Service Pack of your SQL Server environment, you can use your SQL Server management environment to run the following SQL Query:

SELECT SERVERPROPERTY('ProductLevel')